Diagram Billing_Invoice

Defincja diagramu Billing_Invoice

Name

Billing_Invoice

Code

Billing_Invoice

Comment

Defines
- payers paying for medical services
- invoices


Lista tabel diagramu

Name

Code

ActionType

ActionType

Address

Address

BankAccount

BankAccount

ChemotherapyInvoice

ChemotherapyInvoice

Contractor

Contractor

ContractorData

ContractorData

DictionaryValue

DictionaryValue

Discounts

Discounts

Document

Document

DocumentData

DocumentData

DocumentType

DocumentType

DocumentTypeText

DocumentTypeText

Employer

Employer

Episode

Episode

Event

Event

ExternalIdentifier

ExternalIdentifier

ExternalOrgUnit

ExternalOrgUnit

Insurer

Insurer

Item

Item

LContractorAddress

LContractorAddress

LDocumentDocument

LDocumentDocument

LDocumentIdentifier

LDocumentIdentifier

LGPEffectPerfContractService

LGPEffectPerfContractService

LPerfContrServStatus

LPerfContrServStatus

LPerfServType

LPerfServType

LPriceVATRate

LPriceVATRate

NFZDrugData

NFZDrugData

PaymentType

PaymentType

PaymentTypeText

PaymentTypeText

PCSAdditionalData

PCSAdditionalData

PCSAdditionalDataType

PCSAdditionalDataType

PerfContractService

PerfContractService

PerfContractServiceInvoice

PerfContractServiceInvoice

PerfResource

PerfResource

PerfService

PerfService

PerfServPerfServTimeDependency

PerfServPerfServTimeDependency

Person

Person

Personnel

Personnel

Price

Price

ResourceItem

ResourceItem

Service

Service

ServiceType

ServiceType

Unit

Unit

UnitText

UnitText

VATRate

VATRate

VATRateText

VATRateText


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_91

R_91

Document

LDocumentDocument

DocumentID

 

 

R_92

R_92

Document

LDocumentDocument

Doc_DocumentID

 

 

R_147

R_147

PerfService

PerfResource

PerfServiceID

 

 

R_168

R_168

Employer

Contractor

EmployerID

 

 

R_305

R_305

Unit

ResourceItem

UnitID

 

 

R_311

R_311

Unit

UnitText

UnitID

 

 

R_350

R_350

Event

PerfContractService

EventID

 

 

R_439

R_439

Insurer

Contractor

InsurID

 

 

R_440

R_440

VATRate

VATRateText

VatRateID

 

 

R_442

R_442

DocumentType

DocumentTypeText

DocumentTypeID

 

 

R_444

R_444

Service

Price

ServID

 

 

R_445

R_445

ResourceItem

Price

ResourceID

 

 

R_446

R_446

DocumentType

Document

DocumentTypeID

 

 

R_452

R_452

Price

LPriceVATRate

PriceID

 

 

R_453

R_453

VATRate

LPriceVATRate

VatRateID

 

 

R_454

R_454

Contractor

Document

ContractorID

 

 

R_455

R_455

Price

Discounts

PriceID

 

 

R_456

R_456

Discounts

Contractor

DiscountID

 

 

R_457

R_457

Document

Item

DocumentID

 

 

R_458

R_458

VATRate

Item

VatRateID

 

 

R_459

R_459

PerfService

Item

PerfServiceID

 

 

R_460

R_460

PerfResource

Item

PerfResourceID

 

 

R_508

R_508

ExternalIdentifier

Document

IdentifierTypeID; ExternalValue

 

 

R_509

R_509

Address

LContractorAddress

AddressID

 

 

R_510

R_510

Contractor

LContractorAddress

ContractorID

 

 

R_512

R_512

PaymentType

PaymentTypeText

PaymentTypeID

 

 

R_513

R_513

Person

Contractor

PersonID

 

 

R_514

R_514

PaymentType

Document

PaymentTypeID

 

 

R_562

R_562

PerfContractService

Item

ContractServicePerfID

 

 

R_599

R_599

Document

LDocumentIdentifier

DocumentID

 

 

R_600

R_600

ExternalIdentifier

LDocumentIdentifier

IdentifierTypeID; ExternalValue

 

 

R_623

R_623

Unit

Item

UnitID

 

 

R_674

R_674

ResourceItem

PerfResource

ResourceID

 

 

R_687

R_687

ExternalOrgUnit

Contractor

ExternalOrgUnitID

 

 

R_1554

R_1554

Document

DocumentData

DocumentID

 

 

R_1760

R_1760

PaymentType

Item

PaymentTypeID

 

 

R_1770

R_1770

Person

Document

PersonID

 

 

R_1920

R_1920

DictionaryValue

LGPEffectPerfContractService

DictionaryValueID

 

 

R_8180

R_8180

Service

Item

ServID

 

 

R_8640

R_8640

PerfContractService

ChemotherapyInvoice

ContractServicePerfID

 

 

R_8765

R_8765

ServiceType

Item

ServiceTypeID

 

 

R_8830

R_8830

DictionaryValue

LPerfServType

PerfServTypeID

 

 

R_8831

R_8831

PerfService

LPerfServType

PerfServiceID

 

 

R_8875

R_8875

ResourceItem

NFZDrugData

ResourceID

 

 

R_8876

R_8876

Unit

NFZDrugData

UnitID

 

 

R_8923

R_8923

PerfResource

PerfServPerfServTimeDependency

PerfResourceID

 

 

R_9001

R_9001

Insurer

Person

InsurID

 

 

R_9047

R_9047

PerfContractService

PCSAdditionalData

ContractServicePerfID

 

 

R_9048

R_9048

PCSAdditionalDataType

PCSAdditionalData

PCSAdditionalDataTypeID

 

 

R_9049

R_9049

ResourceItem

PCSAdditionalData

ResourceID

 

 


2